Using Cost of Goods Sold

Select FIND to look up a Cost of Goods Batch by:

• Item - Find the cost of goods batches for a particular Item.
• Batch - Find a cost of goods batch by batch number.
• Order - Find a cost of goods batch for a particular sales order number.
• Invoice - Find a cost of goods batch for a particular invoice number.

 

Item

Select ITEM to find all previous cost of goods batches for a particular item.

Enter the item mask in the Item field. Select the item from the list. See Navigating Net Yield - Selecting an Item Code for directions on how to enter an item code.

The Item Id and Name will be displayed along with a " Select A Cost of Goods Sold Batch" window with the following information:

• EXIT – Select EXIT to exit the Cost of Goods option.
• UNCOSTED - Select UNCOSTED to run the Cost of Goods Preview , Run the Cost of Goods process or Skip Items on Next Costing the next time Cost of Goods is run.
  • The following options will appear if you select UNCOSTED:
    • Print Preview - Select Print Preview to print the Costed Items Batch Preview report. The message line displays the following message: "Warning, This Process Could Take Several Minutes, Continue? No/Yes".
    • Select no to leave this option and return to the first Select An Option window.
    • Select yes to continue costing the item. The following message will display: "Opening files, Work Order Costing" when each work order is being costed. "Costing Item: XXXXXXXX" when every inventory item is being costed. If the item can be costed, command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Cost of Goods Preview Report.
    • Cost Item - Select Cost Item to run the cost of goods sold process. The message line displays "Warning, This Process Could Take Several Minutes, Continue? No/Yes".
    • Select no to exit this option and return to the first Select An Option window.
    • Select yes to continue with costing. The message line displays "Opening Files, Work Order Costing" when each Work Order is being costed.Costing Item: XXXXXXXX" when every inventory item is being costed. If the item can be costed, command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Cost of Goods Batch Report. The user will be returned to the Select An Option or A Previous Costing Batch window.

    If there are no uncosted items , the following message will appear " No uncosted Records found !!! Space Bar to Continue. Press the space bar to return to the "Select An Option Or A Previous Costing batch " window.

  • A list of the previous cost of goods batches for the item with the following information about each batch:
    • Batch Number.
    • Date and Time the batch was processed.
    • The User Id of the user that ran the cost of goods batch or EOD in the batch was created during the Close End of Day process.
    • Items - The number of Items costed.
    • Lines - The number of sales order lines costed.
    • Lots - The number of lots used to calculate the cost and assigned to the sales order lines.
    • Costed - The total value of the cost of goods batch.
    • Returned - The value returned through a cost of goods batch reversal.
      •  Scroll to the batch and press Enter to select.
        • The following options will appear:
          • Exit - Select EXIT to exit the Cost of Goods Batch selected.
          • Select - Select SELECT to select a single sales order line
            • You will have the option to Exit and return to the cost of goods batch selected or Reverse XXX UOM of costs on xx Order lines to reverse the previous costed batch for the sales order line selected . See Reversing Cost of Goods Batch below.
          • Print - Select Print to print the details of the cost of goods batch for the item select. Command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Cost of Goods Batch Report.
          • Reverse XXX UOM of costs on xx Order lines - Select Reverse to reverse the previous costed batch for the sales order line selected . See Reversing Cost of Goods Batch below.

 

Batch

Select BATCH to find a cost of goods batch by batch number.

Enter the Batch Number in the Batch field.

The Batch Number and the date and time the batch was created and User ID or EOD will appear along with a " Select An Item From Batch xxxxx" window with the following information:

• EXIT – Select EXIT to exit the Cost of Goods Batch selected.
• ALL ITEMS - Select ALL ITEMS to reprint the cost of goods batch for all items original costed on the Batch or to reverse the costing for the entire batch.
  • The following options will appear:
  • Exit - Select EXIT to exit the Cost of Goods Batch select.
  • Print - Select Print to print the details of the cost of goods batch for the batch selected. Command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Cost of Goods Batch Report.
  • Reverse XXX UOM of costs on xx Order lines - Select Reverse to reverse the previous costed batch for the sales order line selected . See Reversing Cost of Goods Batches below.
• A list of the Items originally costed on the batch with the following information about each item:
  • Item Number
  • Item Name
  • Lines - The number of sales order lines costed.
  • Lots - The number of lots used to calculate the cost and assigned to the sales order lines.
  • Costed - The total number or units and units of measure for the item costed and total value of the cost of goods batch for the item.
  • Returned - The quantity returned through a cost of goods reversal and the unit of measure for the item that was reversed.
    • Scroll down the list to select an Item.
      • The following information about the selected batch will appear:
        • Item - The Item ID.
        • Name - The Item Name
        • Batch - The Batch Number date and time the batch was created with the User Id or EOD if run from EOD.
        • Costed - The total quantity and unit of measure for the item costed.
          • For each sales order line
            • The quantity and unit of measure for the costed item.
            • The Customer ID.
            • The Sales Order Number.
            • The unit cost and unit of measure for the item costed.
    • The following options will appear:
      • Exit - Select EXIT to exit the Cost of Goods Batch selected.
      • Select - Select SELECT to select a single sales order line
        • You will have the option to Exit and return to the cost of goods batch selected or Reverse XXX UOM of costs on xx Order lines to reverse the previous costed batch for the sales order line selected . See Reversing Cost of Goods Batches below.
      • Print - Select Print to print the details of the cost of goods batch for the item selected. Command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Cost of Goods Batch Report.
      • Reverse XXX UOM of costs on xx Order lines - Select Reverse to reverse the previous costed batch for the sales order line selected . See Reversing Cost of Goods Batches below.

 

Order

Select by ORDER to find the Cost of Goods Batch or Batches for a particular Sales Order by order number.

Enter the Sales Order Number in the Order Field.

The Sales Order and Invoice Number and Customer ID and Name will be displayed along with a " Select An Line From Order xxxxxx" window with the following options.

• Exit - Select EXIT to exit the Cost of Goods Batch selected.
• TRACE - Select Trace to display the information reported as part of Trace reporting if Trace reporting has been activated in Interface Options. See Trace Overview for more information on Trace
  • A list of the costed sales order lines with the following information:
    • Item Number.
    • Item Name.
    • Batch - The batch number that was used to cost the sales order line.
    • Lots - The number of lots used to calculate the cost and assigned to the sales order lines.
    • Costed - The total number or units and units of measure for the item costed and total value of the cost of goods batch for the item.
    • Returned - the quantity returned through a cost of goods reversal and the unit of measure for the item that was reversed.
      • Scroll down the list and press enter to select a sales order line.
      • The following information about the selected batch will appear:
        • Item - The Item ID.
        • Name - The Item Name.
        • Batch - The Batch Number date and time the batch was created with the User Id or EOD if run from EOD.
        • Costed - The total quantity and unit of measure for the item costed.
          • For each sales order line
            • The quantity and unit of measure for the costed item.
            • The Customer ID.
            • The Sales Order Number.
            • The unit cost and unit of measure for the item costed.

    • The following options will appear:
      • Exit - Select EXIT to exit the Cost of Goods Batch selected.
      • Select - Select SELECT to select a single sales order line
        • You will have the option to Exit and return to the cost of goods batch selected or Reverse XXX UOM of costs on xx Order lines to reverse the previous costed batch for the sales order line selected . See Reversing Cost of Goods Batches below.
      • Print - Select Print to print the details of the cost of goods batch for the item selected. Command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Cost of Goods Batch Report.

• The list of items will only included items that have costed. Uncosted items will not be displayed. If the entire sales order is uncosted the following message will appear:
  • " Nothing costed found for Order xxxxxx !!! Space Bar to Continue "

 

Invoice

 

Select by Invoice to find the Cost of Goods Batch or Batches for a particular Invoice by Invoice Number

Enter the Invoice Number in the Invoice Field.

The Sales Order and Invoice Number and Customer ID and Name will be displayed along with a " Select An Line From Order xxxxxx" window with the following options.

• Exit - Select EXIT to exit the Cost of Goods Batch selected
• TRACE - Select Trace to display the information reported as part of Trace reporting if Trace reporting has been activated in Interface Options. See Trace Overview for more information on Trace
  • A list of the costed sales order lines with the following information:
    • Item Number.
    • Item Name.
    • Batch - The batch number that was used to cost the sales order line.
    • Lots - The number of lots used to calculate the cost and assigned to the sales order lines.
    • Costed - The total number or units and units of measure for the item costed and total value of the cost of goods batch for the item.
    • Returned - The quantity returned through a cost of goods reversal and the unit of measure for the item that was reversed.
      • Scroll down the list and press enter to select a sales order line.
      • The following information about the selected batch will appear:
        • Item - The Item ID.
        • Name - The Item Name.
        • Batch - The Batch Number date and time the batch was created with the User Id or EOD if run from EOD.
        • Costed - The total quantity and unit of measure for the item costed.
          • For each sales order line
            • The quantity and unit of measure for the costed item.
            • The Customer ID.
            • The Sales Order Number.
            • The unit cost and unit of measure for the item costed.

    • The following options will appear:
      • Exit - Select EXIT to exit the Cost of Goods Batch selected.
      • Select - Select SELECT to select a single sales order line
        • You will have the option to Exit and return to the cost of goods batch selected or Reverse XXX UOM of costs on xx Order lines to reverse the previous costed batch for the sales order line selected. Command options will appear allowing you to print or choose from a set of other print options. See Reversing Cost of Goods Batches below.
      • Print - Select Print to print the details of the cost of goods batch for the item selected. See Printing for more information on the Cost of Goods Batch Report.

Select UNCOSTED to run the Cost of Goods Preview , Run the Cost of Goods process or Skip Items on Next Costing the next time Cost of Goods is run.

The following command line options will appear:

• Exit - Select Exit to Exit the Uncosted option and return to the Select An Option or A Previous Costing Batch window.
• Preview - Select Preview to run a Cost of Goods Sold Preview Report.
• Cost of Goods Sold - Select Cost of Goods Sold to run the cost of goods sold process.
• Skip Items on Next Costing - Select Skip Items on Next Costing to exclude items from being costed during the next cost of goods process.

 

Preview

Select Preview to run a Cost of Goods Sold Batch Preview Report.

The message line displays the following message: "Warning, This Process Could Take Several Minutes, Continue? No/Yes".

• Select No to leave this option and return to the first Select An Option window.
• Select Yes to continue costing the item. The following message will display: "Opening files, Work Order Costing" when each work order is being costed. "Costing Item: XXXXXXXX" when every inventory item is being costed. If the item can be costed, command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Cost of Goods Preview Report

 

Cost of Goods Sold

Select Cost of Goods Sold or Cost Item to run the cost of goods sold process

The message line displays "Warning, This Process Could Take Several Minutes, Continue? No/Yes".

• Select No to exit this option and return to the first Select An Option window.
• Select Yes to continue with costing. The message line displays "Opening Files, Work Order Costing" when each Work Order is being costed.Costing Item: XXXXXXXX" when every inventory item is being costed. If the item can be costed, command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Cost of Goods Batch Report. The user will be returned to the Select An Option or A Previous Costing Batch window.

 

Skip Items on Next Costing

Select Skip Items on Next Costing to exclude an item or items from being costed the next time Cost of Goods Sold is run either from the menu or as part of the Close End of Day Process. This is useful if you know an item is not priced correctly and you don't want it to run in COGS. It will be priced the next time COGS is run unless you skip it again. A Select An Option window will appear:

• Exit – Select Exit to exit the SKIP ITEMS NEXT COGS option.
• Add – Select Add to add on items to be skipped next time the Cost of Goods is run.
  • At the ITEM field, enter the item group or press F3 to choose from a list of item groups. A Select An Item window will appear; select the item you would like to skip when COGS is run.
  • The item name will appear in the NAME field.
  • A "Y" will appear in the SKIP NEXT COGS field. Command options will appear:
    • Select Update to add the item to the list of items to be skipped when COGS is next run.
    • Select Exit to return to the ITEM field.
• PRINT LIST – Select PRINT LIST to print a list of items currently set to skip the next time the Cost of Goods Sold is run. The list will include the item ID and item name. Command options will appear allowing you to print or choose from a set of other print options.

Scroll down the list of Previously costed batches and press enter to select.

The Batch Number and the date and time the batch was created and User ID or EOD will appear along with a " Select An Item From Batch xxxxx" window with the following information:

• EXIT – Select EXIT to exit the Cost of Goods Batch selected.
• ALL ITEMS - Select ALL ITEMS to reprint the cost of goods batch for all items original costed on the Batch or to reverse the costing for the entire batch .
  • The following options will appear:
  • Exit - Select EXIT to exit the Cost of Goods Batch selected.
  • Print - Select Print to print the details of the cost of goods batch for the item selected. See Printing for more information on the Cost of Goods Batch Report.
  • Reverse XXX UOM of costs on xx Order lines in Batch xxxxx - Select Reverse to reverse the previous costed batch for the sales order line selected. See Reversing Cost of Goods Batch below.
• A list of the Items originally costed on the batch with the following information about each item:
  • Item Number.
  • Item Name.
  • Lines - The number of sales order lines costed.
  • Lots - The number of lots used to calculate the cost and assigned to the sales order lines.
  • Costed - The total number or units and units of measure for the item costed and total value of the cost of goods batch for the item.
  • Returned - The quantity returned through a cost of goods reversal and the unit of measure for the item that was reversed.
    • Scroll down the list to select an Item.
    • The following information about the selected batch will appear:
      • Item - The Item ID.
      • Name - The Item Name.
      • Batch - The Batch Number date and time the batch was created with the User Id or EOD if run from EOD.
      • Costed - The total quantity and unit of measure for the item costed
        • For each sales order line
          • The quantity and unit of measure for the costed item.
          • The Customer ID.
          • The Sales Order Number.
          • The unit cost and unit of measure for the item costed.
    • The following options will appear:
      • Exit - Select EXIT to exit the Cost of Goods Batch selected.
      • Select - Select SELECT to select a single sales order line.
        • You will have the option to Exit and return to the cost of goods batch selected or Reverse XXX UOM of costs on xx Order lines to reverse the previous costed batch for the sales order line selected. Command options will appear allowing you to print or choose from a set of other print options. See Reversing Cost of Goods Batches below.
      • Print - Select Print to print the details of the cost of goods batch for the item selected. See Printing for more information on the Cost of Goods Batch Report.
      • Reverse XXX UOM of costs on xx Order lines - Select Reverse to reverse the previous costed batch for the sales order line selected . See Reversing Cost of Goods Batch below.

 

 

Cost of Goods Batches can be reversed. A reversal of a batch will return the item back to inventory at the costed quantity and value and return the sales order line back to uncosted . The inventory quantity and/or value can then be adjusted via an Inventory Adjustment and the item costed again at the adjusted value. Reversing a costed batch for an item or order will correct any gross margin item cost issues. Once a batch is reversed it cannot be reversed again. Items, orders, and batches with a reversed cost show as "Returned" when the item, order, or batch is selected . Reversed batches do not appear in the batch selection window. The reversal of the batch will post to the accounting period in which it was reversed.

 

The reversal of a cost can be done from each of the following menu options: Find Item,Batch,Order, Invoice or selecting a batch from the "Select An Option or a Previous Costing Batch" selection window.

Once the " Reverse XXX UOM of costs on xx Order lines " option has been selected from one of the above options , the following message line will appear:

• " Do you really want to Reverse xxxx UOM of costs on xx Order LInes No/Yes.
  • Select No to Exit the Reverse Cost option.
  • Select Yes to reverse the cost of goods batch for the item, sales order or batch selected.
    • A "Are You Sure No/Yes " message line will appear
      • Select No to Exit the Reverse Cost option.
      • Select Yes to reverse the cost of goods batch for the item, sales order or batch selected.
        • Command options will appear allowing you to print or choose from a set of other print options. See Printing for more information on the Cost of Goods Batch Report.